Interview Questions

1. Debugging will help us find and resolve an issue in an SQL Server Integration Services (SSIS) package?

Options:

a. True

b. False

Reveal Answer

2. You've designed a "parent" package that will execute several "child" packages. You did like to pass the database connection string from the parent to each of the child packages as they're run. How will you implement the desired functionality?

Options:

a. By referencing the parent package's variables from the child packages using a package configuration

b. Add the variables to be used by the child packages to the parent package's Shared Variable collection

c. This functionality is not supported by SSIS

d. Establish an inter-program named pipe between the packages at runtime

Reveal Answer

3. SSIS packages can be created using SQL Server Management Studio (SSMS)?

Options:

a. True

b. False

Reveal Answer

4. When viewing data flow pipeline data using a data viewer, how can you instantly tell which transform in the SSIS pipeline last updated a specific data value?

Options:

a. Right click on the value and click the \view line age\ menu option

b. By reviewing the package progress window

c. By turning on detailed package logging and reviewing the lot after the next test run

d. SSIS does not provide this functionality

Reveal Answer

5. A break point will pause the execution of the package at a certain point?

Options:

a. True

b. False

Reveal Answer

6. Breakpoint can be specified at?

Options:

a. pre-execution or post-execution

b. loop iteration

c. on warning

d. on error event of a single task container or package

e. All the Above

Reveal Answer

7. What are the three basic methods for debugging the package?

Options:

a. Executing the package partially

b. Debugging Control Flow tasks

c. Debugging Data Flow task

d. All the Above

Reveal Answer

8. How do you upgrade an SSIS Package?

Options:

a. Recode the package based on the functionality in SQL Server DTS

b. Use the Migrate DTS 2000 Package wizard in BIDS then recode any portion of the package that is not accurate

c. None the Above

Reveal Answer

9. How many ways we can debug the control flow in SSIS?

Options:

a. Setting up breakpoints

b. Using Progress tab information

c. Using Debug windows

d. None of the above

Reveal Answer

10. How many ways we can set up break points in SSIS?

Options:

a. 2

b. 4

c. 5

d. 1

Reveal Answer

Interview Questions and Answer

1. Debugging will help us find and resolve an issue in an SQL Server Integration Services (SSIS) package?

2. You've designed a "parent" package that will execute several "child" packages. You did like to pass the database connection string from the parent to each of the child packages as they're run. How will you implement the desired functionality?

3. SSIS packages can be created using SQL Server Management Studio (SSMS)?

4. When viewing data flow pipeline data using a data viewer, how can you instantly tell which transform in the SSIS pipeline last updated a specific data value?

5. A break point will pause the execution of the package at a certain point?

6. Breakpoint can be specified at?

7. What are the three basic methods for debugging the package?

8. How do you upgrade an SSIS Package?

9. How many ways we can debug the control flow in SSIS?

10. How many ways we can set up break points in SSIS?

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources